package com.golookon.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

@SuppressWarnings("serial")
@Entity
@Table(name = "us_state_city")
@NamedQueries({ 
	@NamedQuery(name = "StateCity.findAllStates", query = "SELECT DISTINCT sc.state FROM StateCity sc ORDER BY sc.state"),
	@NamedQuery(name = "StateCity.findCitiesByState", query = "SELECT sc.city FROM StateCity sc WHERE sc.state = :state ORDER BY sc.city")})
public class StateCity extends BaseEntity {
	@Column(name = "city_number")
	private String cityNumber;
	@Column(name = "city")
	private String city;
	@Column
	private String st;
	@Column
	private String state;
	@Column
	private float lo;
	@Column
	private float la;

	public String getCityNumber() {
		return cityNumber;
	}

	public void setCityNumber(String cityNumber) {
		this.cityNumber = cityNumber;
	}

	public String getCity() {
		return city;
	}

	public void setCity(String city) {
		this.city = city;
	}

	public String getSt() {
		return st;
	}

	public void setSt(String st) {
		this.st = st;
	}

	public String getState() {
		return state;
	}

	public void setState(String state) {
		this.state = state;
	}

	public float getLo() {
		return lo;
	}

	public void setLo(float lo) {
		this.lo = lo;
	}

	public float getLa() {
		return la;
	}

	public void setLa(float la) {
		this.la = la;
	}

}
